Dataset statistics
| Number of variables | 10 |
|---|---|
| Number of observations | 953 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 310.1 KiB |
| Average record size in memory | 333.3 B |
Variable types
| Text | 4 |
|---|---|
| Numeric | 6 |
released_year is highly overall correlated with in_spotify_playlists | High correlation |
in_spotify_playlists is highly overall correlated with released_year | High correlation |
track_id has unique values | Unique |
in_spotify_charts has 405 (42.5%) zeros | Zeros |
Reproduction
| Analysis started | 2024-06-26 16:55:30.614825 |
|---|---|
| Analysis finished | 2024-06-26 16:55:34.799197 |
| Duration | 4.18 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
track_id
Text
UNIQUE
| Distinct | 953 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 59.7 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.996852 |
| Min length | 4 |
Characters and Unicode
| Total characters | 6668 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 953 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 4082370 |
|---|---|
| 2nd row | 6247887 |
| 3rd row | 6974739 |
| 4th row | 2362023 |
| 5th row | 4386478 |
| Value | Count | Frequency (%) |
| 4082370 | 1 | 0.1% |
| 5374189 | 1 | 0.1% |
| 3197174 | 1 | 0.1% |
| 6974739 | 1 | 0.1% |
| 2362023 | 1 | 0.1% |
| 4386478 | 1 | 0.1% |
| 5031502 | 1 | 0.1% |
| 1892693 | 1 | 0.1% |
| 7366228 | 1 | 0.1% |
| 5563881 | 1 | 0.1% |
| Other values (943) | 943 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 752 | |
| 6 | 733 | |
| 2 | 716 | |
| 4 | 689 | |
| 1 | 689 | |
| 7 | 681 | |
| 5 | 673 | |
| 8 | 642 | |
| 0 | 551 | |
| 9 | 541 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 6667 | |
| Other Punctuation | 1 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 752 | |
| 6 | 733 | |
| 2 | 716 | |
| 4 | 689 | |
| 1 | 689 | |
| 7 | 681 | |
| 5 | 673 | |
| 8 | 642 | |
| 0 | 551 | |
| 9 | 541 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 6668 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 752 | |
| 6 | 733 | |
| 2 | 716 | |
| 4 | 689 | |
| 1 | 689 | |
| 7 | 681 | |
| 5 | 673 | |
| 8 | 642 | |
| 0 | 551 | |
| 9 | 541 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6668 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 752 | |
| 6 | 733 | |
| 2 | 716 | |
| 4 | 689 | |
| 1 | 689 | |
| 7 | 681 | |
| 5 | 673 | |
| 8 | 642 | |
| 0 | 551 | |
| 9 | 541 |
track_name
Text
| Distinct | 943 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 73.0 KiB |
Length
| Max length | 123 |
|---|---|
| Median length | 62 |
| Mean length | 16.832109 |
| Min length | 2 |
Characters and Unicode
| Total characters | 16041 |
|---|---|
| Distinct characters | 82 |
| Distinct categories | 11 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 933 ? |
|---|---|
| Unique (%) | 97.9% |
Sample
| 1st row | Seven (feat. Latto) (Explicit Ver.) |
|---|---|
| 2nd row | LALA |
| 3rd row | vampire |
| 4th row | Cruel Summer |
| 5th row | WHERE SHE GOES |
| Value | Count | Frequency (%) |
| 95 | 3.2% | |
| the | 78 | 2.6% |
| feat | 61 | 2.0% |
| with | 46 | 1.5% |
| you | 40 | 1.3% |
| me | 39 | 1.3% |
| i | 35 | 1.2% |
| a | 26 | 0.9% |
| of | 25 | 0.8% |
| love | 24 | 0.8% |
| Other values (1499) | 2530 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2046 | 12.8% | |
| e | 1355 | 8.4% |
| o | 910 | 5.7% |
| a | 890 | 5.5% |
| i | 796 | 5.0% |
| r | 697 | 4.3% |
| t | 665 | 4.1% |
| n | 628 | 3.9% |
| s | 536 | 3.3% |
| l | 457 | 2.8% |
| Other values (72) | 7061 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 9563 | |
| Uppercase Letter | 3427 | 21.4% |
| Space Separator | 2046 | 12.8% |
| Other Punctuation | 280 | 1.7% |
| Other Symbol | 179 | 1.1% |
| Open Punctuation | 169 | 1.1% |
| Close Punctuation | 160 | 1.0% |
| Decimal Number | 139 | 0.9% |
| Dash Punctuation | 75 | 0.5% |
| Math Symbol | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1355 | |
| o | 910 | |
| a | 890 | 9.3% |
| i | 796 | 8.3% |
| r | 697 | 7.3% |
| t | 665 | 7.0% |
| n | 628 | 6.6% |
| s | 536 | 5.6% |
| l | 457 | 4.8% |
| h | 368 | 3.8% |
| Other values (16) | 2261 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 300 | 8.8% |
| T | 262 | 7.6% |
| A | 250 | 7.3% |
| M | 248 | 7.2% |
| L | 211 | 6.2% |
| B | 193 | 5.6% |
| I | 164 | 4.8% |
| R | 164 | 4.8% |
| C | 158 | 4.6% |
| E | 157 | 4.6% |
| Other values (16) | 1320 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 105 | |
| ' | 47 | |
| & | 35 | 12.5% |
| , | 31 | 11.1% |
| : | 18 | 6.4% |
| " | 18 | 6.4% |
| ! | 12 | 4.3% |
| ? | 11 | 3.9% |
| / | 2 | 0.7% |
| # | 1 | 0.4% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 36 | |
| 1 | 29 | |
| 0 | 23 | |
| 9 | 17 | |
| 5 | 16 | |
| 4 | 6 | 4.3% |
| 3 | 5 | 3.6% |
| 8 | 3 | 2.2% |
| 6 | 3 | 2.2% |
| 7 | 1 | 0.7% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 162 | |
| [ | 7 | 4.1% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 153 | |
| ] | 7 | 4.4% |
Math Symbol
| Value | Count | Frequency (%) |
| | | 1 | |
| + | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 2046 |
Other Symbol
| Value | Count | Frequency (%) |
| � | 179 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 75 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12990 | |
| Common | 3051 | 19.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1355 | 10.4% |
| o | 910 | 7.0% |
| a | 890 | 6.9% |
| i | 796 | 6.1% |
| r | 697 | 5.4% |
| t | 665 | 5.1% |
| n | 628 | 4.8% |
| s | 536 | 4.1% |
| l | 457 | 3.5% |
| h | 368 | 2.8% |
| Other values (42) | 5688 |
Common
| Value | Count | Frequency (%) |
| 2046 | ||
| � | 179 | 5.9% |
| ( | 162 | 5.3% |
| ) | 153 | 5.0% |
| . | 105 | 3.4% |
| - | 75 | 2.5% |
| ' | 47 | 1.5% |
| 2 | 36 | 1.2% |
| & | 35 | 1.1% |
| , | 31 | 1.0% |
| Other values (20) | 182 | 6.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15862 | |
| Specials | 179 | 1.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2046 | 12.9% | |
| e | 1355 | 8.5% |
| o | 910 | 5.7% |
| a | 890 | 5.6% |
| i | 796 | 5.0% |
| r | 697 | 4.4% |
| t | 665 | 4.2% |
| n | 628 | 4.0% |
| s | 536 | 3.4% |
| l | 457 | 2.9% |
| Other values (71) | 6882 |
Specials
| Value | Count | Frequency (%) |
| � | 179 |
artists_name
Text
| Distinct | 645 |
|---|---|
| Distinct (%) | 67.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.6 KiB |
Length
| Max length | 117 |
|---|---|
| Median length | 66 |
| Mean length | 16.114376 |
| Min length | 1 |
Characters and Unicode
| Total characters | 15357 |
|---|---|
| Distinct characters | 75 |
| Distinct categories | 11 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 541 ? |
|---|---|
| Unique (%) | 56.8% |
Sample
| 1st row | Latto, Jung Kook |
|---|---|
| 2nd row | Myke Towers |
| 3rd row | Olivia Rodrigo |
| 4th row | Taylor Swift |
| 5th row | Bad Bunny |
| Value | Count | Frequency (%) |
| the | 66 | 2.5% |
| bad | 41 | 1.6% |
| bunny | 40 | 1.5% |
| taylor | 38 | 1.5% |
| swift | 38 | 1.5% |
| weeknd | 37 | 1.4% |
| kendrick | 23 | 0.9% |
| lamar | 23 | 0.9% |
| sza | 23 | 0.9% |
| lil | 21 | 0.8% |
| Other values (1042) | 2240 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1639 | 10.7% | |
| a | 1339 | 8.7% |
| e | 1196 | 7.8% |
| i | 868 | 5.7% |
| n | 836 | 5.4% |
| r | 799 | 5.2% |
| o | 730 | 4.8% |
| l | 569 | 3.7% |
| , | 529 | 3.4% |
| t | 438 | 2.9% |
| Other values (65) | 6414 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 9945 | |
| Uppercase Letter | 3030 | 19.7% |
| Space Separator | 1639 | 10.7% |
| Other Punctuation | 569 | 3.7% |
| Other Symbol | 91 | 0.6% |
| Decimal Number | 59 | 0.4% |
| Dash Punctuation | 15 | 0.1% |
| Open Punctuation | 3 | < 0.1% |
| Close Punctuation | 3 | < 0.1% |
| Connector Punctuation | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1339 | |
| e | 1196 | |
| i | 868 | 8.7% |
| n | 836 | 8.4% |
| r | 799 | 8.0% |
| o | 730 | 7.3% |
| l | 569 | 5.7% |
| t | 438 | 4.4% |
| s | 377 | 3.8% |
| u | 360 | 3.6% |
| Other values (16) | 2433 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 297 | 9.8% |
| B | 255 | 8.4% |
| T | 228 | 7.5% |
| L | 200 | 6.6% |
| M | 197 | 6.5% |
| C | 185 | 6.1% |
| D | 167 | 5.5% |
| A | 162 | 5.3% |
| K | 128 | 4.2% |
| R | 127 | 4.2% |
| Other values (16) | 1084 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 19 | |
| 1 | 15 | |
| 0 | 8 | |
| 4 | 6 | 10.2% |
| 7 | 4 | 6.8% |
| 5 | 3 | 5.1% |
| 8 | 2 | 3.4% |
| 3 | 1 | 1.7% |
| 9 | 1 | 1.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 529 | |
| . | 18 | 3.2% |
| & | 11 | 1.9% |
| ! | 5 | 0.9% |
| ' | 4 | 0.7% |
| * | 1 | 0.2% |
| : | 1 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 1639 |
Other Symbol
| Value | Count | Frequency (%) |
| � | 91 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 15 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 3 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 3 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 2 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12975 | |
| Common | 2382 | 15.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 1339 | 10.3% |
| e | 1196 | 9.2% |
| i | 868 | 6.7% |
| n | 836 | 6.4% |
| r | 799 | 6.2% |
| o | 730 | 5.6% |
| l | 569 | 4.4% |
| t | 438 | 3.4% |
| s | 377 | 2.9% |
| u | 360 | 2.8% |
| Other values (42) | 5463 |
Common
| Value | Count | Frequency (%) |
| 1639 | ||
| , | 529 | 22.2% |
| � | 91 | 3.8% |
| 2 | 19 | 0.8% |
| . | 18 | 0.8% |
| 1 | 15 | 0.6% |
| - | 15 | 0.6% |
| & | 11 | 0.5% |
| 0 | 8 | 0.3% |
| 4 | 6 | 0.3% |
| Other values (13) | 31 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15266 | |
| Specials | 91 | 0.6% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1639 | 10.7% | |
| a | 1339 | 8.8% |
| e | 1196 | 7.8% |
| i | 868 | 5.7% |
| n | 836 | 5.5% |
| r | 799 | 5.2% |
| o | 730 | 4.8% |
| l | 569 | 3.7% |
| , | 529 | 3.5% |
| t | 438 | 2.9% |
| Other values (64) | 6323 |
Specials
| Value | Count | Frequency (%) |
| � | 91 |
artist_count
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5561385 |
| Minimum | 1 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 8 |
| Range | 7 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.89304419 |
|---|---|
| Coefficient of variation (CV) | 0.57388477 |
| Kurtosis | 10.366704 |
| Mean | 1.5561385 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.5440322 |
| Sum | 1483 |
| Variance | 0.79752793 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 1 | 587 | |
| 2 | 254 | |
| 3 | 85 | 8.9% |
| 4 | 15 | 1.6% |
| 5 | 5 | 0.5% |
| 6 | 3 | 0.3% |
| 8 | 2 | 0.2% |
| 7 | 2 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 587 | |
| 2 | 254 | |
| 3 | 85 | 8.9% |
| 4 | 15 | 1.6% |
| 5 | 5 | 0.5% |
| 6 | 3 | 0.3% |
| 7 | 2 | 0.2% |
| 8 | 2 | 0.2% |
| Value | Count | Frequency (%) |
| 8 | 2 | 0.2% |
| 7 | 2 | 0.2% |
| 6 | 3 | 0.3% |
| 5 | 5 | 0.5% |
| 4 | 15 | 1.6% |
| 3 | 85 | 8.9% |
| 2 | 254 | |
| 1 | 587 |
released_year
Real number (ℝ)
HIGH CORRELATION
| Distinct | 50 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2018.2382 |
| Minimum | 1930 |
|---|---|
| Maximum | 2023 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 KiB |
Quantile statistics
| Minimum | 1930 |
|---|---|
| 5-th percentile | 1999 |
| Q1 | 2020 |
| median | 2022 |
| Q3 | 2022 |
| 95-th percentile | 2023 |
| Maximum | 2023 |
| Range | 93 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 11.116218 |
|---|---|
| Coefficient of variation (CV) | 0.0055078821 |
| Kurtosis | 20.513396 |
| Mean | 2018.2382 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -4.2921176 |
| Sum | 1923381 |
| Variance | 123.5703 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2022 | 402 | |
| 2023 | 175 | |
| 2021 | 119 | 12.5% |
| 2020 | 37 | 3.9% |
| 2019 | 36 | 3.8% |
| 2017 | 23 | 2.4% |
| 2016 | 18 | 1.9% |
| 2014 | 13 | 1.4% |
| 2013 | 13 | 1.4% |
| 2015 | 11 | 1.2% |
| Other values (40) | 106 | 11.1% |
| Value | Count | Frequency (%) |
| 1930 | 1 | 0.1% |
| 1942 | 1 | 0.1% |
| 1946 | 1 | 0.1% |
| 1950 | 1 | 0.1% |
| 1952 | 1 | 0.1% |
| 1957 | 2 | |
| 1958 | 3 | |
| 1959 | 2 | |
| 1963 | 3 | |
| 1968 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 2023 | 175 | |
| 2022 | 402 | |
| 2021 | 119 | 12.5% |
| 2020 | 37 | 3.9% |
| 2019 | 36 | 3.8% |
| 2018 | 10 | 1.0% |
| 2017 | 23 | 2.4% |
| 2016 | 18 | 1.9% |
| 2015 | 11 | 1.2% |
| 2014 | 13 | 1.4% |
released_month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.0335782 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.5664351 |
|---|---|
| Coefficient of variation (CV) | 0.59109786 |
| Kurtosis | -1.1957936 |
| Mean | 6.0335782 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.18475844 |
| Sum | 5750 |
| Variance | 12.71946 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 1 | 134 | |
| 5 | 128 | |
| 3 | 86 | |
| 6 | 86 | |
| 11 | 80 | |
| 12 | 75 | |
| 10 | 73 | |
| 4 | 66 | |
| 7 | 62 | |
| 2 | 61 | |
| Other values (2) | 102 |
| Value | Count | Frequency (%) |
| 1 | 134 | |
| 2 | 61 | |
| 3 | 86 | |
| 4 | 66 | |
| 5 | 128 | |
| 6 | 86 | |
| 7 | 62 | |
| 8 | 46 | 4.8% |
| 9 | 56 | |
| 10 | 73 |
| Value | Count | Frequency (%) |
| 12 | 75 | |
| 11 | 80 | |
| 10 | 73 | |
| 9 | 56 | |
| 8 | 46 | 4.8% |
| 7 | 62 | |
| 6 | 86 | |
| 5 | 128 | |
| 4 | 66 | |
| 3 | 86 |
released_day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.930745 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 13 |
| Q3 | 22 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 9.2019493 |
|---|---|
| Coefficient of variation (CV) | 0.66054969 |
| Kurtosis | -1.2344145 |
| Mean | 13.930745 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.16410207 |
| Sum | 13276 |
| Variance | 84.675871 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 1 | 95 | 10.0% |
| 21 | 44 | 4.6% |
| 13 | 43 | 4.5% |
| 24 | 40 | 4.2% |
| 2 | 39 | 4.1% |
| 20 | 39 | 4.1% |
| 4 | 39 | 4.1% |
| 7 | 39 | 4.1% |
| 6 | 39 | 4.1% |
| 10 | 37 | 3.9% |
| Other values (21) | 499 |
| Value | Count | Frequency (%) |
| 1 | 95 | |
| 2 | 39 | |
| 3 | 32 | 3.4% |
| 4 | 39 | |
| 5 | 25 | 2.6% |
| 6 | 39 | |
| 7 | 39 | |
| 8 | 25 | 2.6% |
| 9 | 36 | 3.8% |
| 10 | 37 | 3.9% |
| Value | Count | Frequency (%) |
| 31 | 19 | |
| 30 | 22 | |
| 29 | 23 | |
| 28 | 21 | |
| 27 | 21 | |
| 26 | 13 | 1.4% |
| 25 | 28 | |
| 24 | 40 | |
| 23 | 23 | |
| 22 | 33 |
in_spotify_playlists
Real number (ℝ)
HIGH CORRELATION
| Distinct | 879 |
|---|---|
| Distinct (%) | 92.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5200.1249 |
| Minimum | 31 |
|---|---|
| Maximum | 52898 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 KiB |
Quantile statistics
| Minimum | 31 |
|---|---|
| 5-th percentile | 268.2 |
| Q1 | 875 |
| median | 2224 |
| Q3 | 5542 |
| 95-th percentile | 22267.4 |
| Maximum | 52898 |
| Range | 52867 |
| Interquartile range (IQR) | 4667 |
Descriptive statistics
| Standard deviation | 7897.609 |
|---|---|
| Coefficient of variation (CV) | 1.5187345 |
| Kurtosis | 9.8761188 |
| Mean | 5200.1249 |
| Median Absolute Deviation (MAD) | 1595 |
| Skewness | 2.9291262 |
| Sum | 4955719 |
| Variance | 62372228 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1150 | 3 | 0.3% |
| 1112 | 3 | 0.3% |
| 356 | 3 | 0.3% |
| 86 | 3 | 0.3% |
| 3006 | 3 | 0.3% |
| 685 | 3 | 0.3% |
| 896 | 3 | 0.3% |
| 811 | 3 | 0.3% |
| 1473 | 3 | 0.3% |
| 892 | 3 | 0.3% |
| Other values (869) | 923 |
| Value | Count | Frequency (%) |
| 31 | 1 | 0.1% |
| 34 | 1 | 0.1% |
| 58 | 1 | 0.1% |
| 67 | 1 | 0.1% |
| 77 | 1 | 0.1% |
| 86 | 3 | |
| 99 | 1 | 0.1% |
| 105 | 1 | 0.1% |
| 130 | 1 | 0.1% |
| 134 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 52898 | 1 | |
| 51979 | 1 | |
| 50887 | 1 | |
| 49991 | 1 | |
| 44927 | 1 | |
| 43899 | 1 | |
| 43257 | 1 | |
| 42798 | 1 | |
| 41751 | 1 | |
| 41231 | 1 |
in_spotify_charts
Real number (ℝ)
ZEROS
| Distinct | 82 |
|---|---|
| Distinct (%) | 8.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.009444 |
| Minimum | 0 |
|---|---|
| Maximum | 147 |
| Zeros | 405 |
| Zeros (%) | 42.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 7.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 16 |
| 95-th percentile | 50 |
| Maximum | 147 |
| Range | 147 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 19.575992 |
|---|---|
| Coefficient of variation (CV) | 1.6300498 |
| Kurtosis | 8.5075814 |
| Mean | 12.009444 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 2.5804821 |
| Sum | 11445 |
| Variance | 383.21945 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 405 | |
| 4 | 48 | 5.0% |
| 2 | 42 | 4.4% |
| 6 | 36 | 3.8% |
| 3 | 18 | 1.9% |
| 8 | 17 | 1.8% |
| 5 | 17 | 1.8% |
| 1 | 16 | 1.7% |
| 13 | 16 | 1.7% |
| 12 | 16 | 1.7% |
| Other values (72) | 322 |
| Value | Count | Frequency (%) |
| 0 | 405 | |
| 1 | 16 | 1.7% |
| 2 | 42 | 4.4% |
| 3 | 18 | 1.9% |
| 4 | 48 | 5.0% |
| 5 | 17 | 1.8% |
| 6 | 36 | 3.8% |
| 7 | 12 | 1.3% |
| 8 | 17 | 1.8% |
| 9 | 15 | 1.6% |
| Value | Count | Frequency (%) |
| 147 | 1 | |
| 130 | 1 | |
| 115 | 1 | |
| 113 | 1 | |
| 110 | 1 | |
| 104 | 1 | |
| 101 | 1 | |
| 100 | 1 | |
| 98 | 1 | |
| 91 | 1 |
streams
Text
| Distinct | 949 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.6 KiB |
Length
| Max length | 102 |
|---|---|
| Median length | 9 |
| Mean length | 9.09234 |
| Min length | 4 |
Characters and Unicode
| Total characters | 8665 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 945 ? |
|---|---|
| Unique (%) | 99.2% |
Sample
| 1st row | 141381703 |
|---|---|
| 2nd row | 133716286 |
| 3rd row | 140003974 |
| 4th row | 800840817 |
| 5th row | 303236322 |
| Value | Count | Frequency (%) |
| 723894473 | 2 | 0.2% |
| 1223481149 | 2 | 0.2% |
| 395591396 | 2 | 0.2% |
| 156338624 | 2 | 0.2% |
| 183706234 | 1 | 0.1% |
| 505671438 | 1 | 0.1% |
| 553634067 | 1 | 0.1% |
| 95217315 | 1 | 0.1% |
| 58149378 | 1 | 0.1% |
| 725980112 | 1 | 0.1% |
| Other values (939) | 939 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1082 | |
| 3 | 949 | |
| 2 | 879 | |
| 6 | 855 | |
| 4 | 822 | |
| 5 | 819 | |
| 7 | 816 | |
| 9 | 816 | |
| 8 | 786 | |
| 0 | 753 | |
| Other values (31) | 88 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 8577 | |
| Lowercase Letter | 74 | 0.9% |
| Uppercase Letter | 14 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 14 | |
| s | 10 | |
| n | 9 | |
| a | 5 | 6.8% |
| i | 5 | 6.8% |
| c | 5 | 6.8% |
| t | 4 | 5.4% |
| l | 3 | 4.1% |
| r | 3 | 4.1% |
| y | 3 | 4.1% |
| Other values (10) | 13 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 3 | |
| A | 2 | |
| L | 1 | 7.1% |
| I | 1 | 7.1% |
| S | 1 | 7.1% |
| E | 1 | 7.1% |
| V | 1 | 7.1% |
| D | 1 | 7.1% |
| K | 1 | 7.1% |
| P | 1 | 7.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1082 | |
| 3 | 949 | |
| 2 | 879 | |
| 6 | 855 | |
| 4 | 822 | |
| 5 | 819 | |
| 7 | 816 | |
| 9 | 816 | |
| 8 | 786 | |
| 0 | 753 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 8577 | |
| Latin | 88 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 14 | |
| s | 10 | 11.4% |
| n | 9 | 10.2% |
| a | 5 | 5.7% |
| i | 5 | 5.7% |
| c | 5 | 5.7% |
| t | 4 | 4.5% |
| l | 3 | 3.4% |
| r | 3 | 3.4% |
| y | 3 | 3.4% |
| Other values (21) | 27 |
Common
| Value | Count | Frequency (%) |
| 1 | 1082 | |
| 3 | 949 | |
| 2 | 879 | |
| 6 | 855 | |
| 4 | 822 | |
| 5 | 819 | |
| 7 | 816 | |
| 9 | 816 | |
| 8 | 786 | |
| 0 | 753 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8665 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 1082 | |
| 3 | 949 | |
| 2 | 879 | |
| 6 | 855 | |
| 4 | 822 | |
| 5 | 819 | |
| 7 | 816 | |
| 9 | 816 | |
| 8 | 786 | |
| 0 | 753 | |
| Other values (31) | 88 | 1.0% |
| artist_count | released_year | released_month | released_day | in_spotify_playlists | in_spotify_charts | |
|---|---|---|---|---|---|---|
| artist_count | 1.000 | 0.195 | 0.033 | -0.001 | -0.112 | 0.010 |
| released_year | 0.195 | 1.000 | -0.124 | 0.108 | -0.660 | 0.146 |
| released_month | 0.033 | -0.124 | 1.000 | 0.104 | -0.041 | -0.031 |
| released_day | -0.001 | 0.108 | 0.104 | 1.000 | -0.037 | 0.025 |
| in_spotify_playlists | -0.112 | -0.660 | -0.041 | -0.037 | 1.000 | 0.128 |
| in_spotify_charts | 0.010 | 0.146 | -0.031 | 0.025 | 0.128 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| track_id | track_name | artists_name | artist_count | released_year | released_month | released_day | in_spotify_playlists | in_spotify_charts | streams | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 4082370 | Seven (feat. Latto) (Explicit Ver.) | Latto, Jung Kook | 2 | 2023 | 7 | 14 | 553 | 147 | 141381703 |
| 1 | 6247887 | LALA | Myke Towers | 1 | 2023 | 3 | 23 | 1474 | 48 | 133716286 |
| 2 | 6974739 | vampire | Olivia Rodrigo | 1 | 2023 | 6 | 30 | 1397 | 113 | 140003974 |
| 3 | 2362023 | Cruel Summer | Taylor Swift | 1 | 2019 | 8 | 23 | 7858 | 100 | 800840817 |
| 4 | 4386478 | WHERE SHE GOES | Bad Bunny | 1 | 2023 | 5 | 18 | 3133 | 50 | 303236322 |
| 5 | 5031502 | Sprinter | Dave, Central Cee | 2 | 2023 | 6 | 1 | 2186 | 91 | 183706234 |
| 6 | 1892693 | Ella Baila Sola | Eslabon Armado, Peso Pluma | 2 | 2023 | 3 | 16 | 3090 | 50 | 725980112 |
| 7 | 7366228 | Columbia | Quevedo | 1 | 2023 | 7 | 7 | 714 | 43 | 58149378 |
| 8 | 5563881 | fukumean | Gunna | 1 | 2023 | 5 | 15 | 1096 | 83 | 95217315 |
| 9 | 5586506 | La Bebe - Remix | Peso Pluma, Yng Lvcas | 2 | 2023 | 3 | 17 | 2953 | 44 | 553634067 |
| track_id | track_name | artists_name | artist_count | released_year | released_month | released_day | in_spotify_playlists | in_spotify_charts | streams | |
|---|---|---|---|---|---|---|---|---|---|---|
| 943 | 4322356 | Privileged Rappers | Drake, 21 Savage | 2 | 2022 | 11 | 4 | 1007 | 0 | 112436403 |
| 944 | 4343383 | The Astronaut | Jin | 1 | 2022 | 10 | 28 | 481 | 9 | 203436468 |
| 945 | 3108815 | BackOutsideBoyz | Drake | 1 | 2022 | 11 | 4 | 1045 | 0 | 93367537 |
| 946 | 8174233 | Broke Boys | Drake, 21 Savage | 2 | 2022 | 11 | 4 | 1060 | 0 | 106249219 |
| 947 | 1587452 | The Great War | Taylor Swift | 1 | 2022 | 10 | 21 | 1274 | 0 | 181382590 |
| 948 | 3476877 | My Mind & Me | Selena Gomez | 1 | 2022 | 11 | 3 | 953 | 0 | 91473363 |
| 949 | 2341529 | Bigger Than The Whole Sky | Taylor Swift | 1 | 2022 | 10 | 21 | 1180 | 0 | 121871870 |
| 950 | 8553734 | A Veces (feat. Feid) | Feid, Paulo Londra | 2 | 2022 | 11 | 3 | 573 | 0 | 73513683 |
| 951 | 6773043 | En La De Ella | Feid, Sech, Jhayco | 3 | 2022 | 10 | 20 | 1320 | 0 | 133895612 |
| 952 | 6728037 | Alone | Burna Boy | 1 | 2022 | 11 | 4 | 782 | 2 | 96007391 |